• All Files

Generating New Schema Columns

In some cases, a user may find it necessary to define extra schema columns, in addition to the four default columns.  When a user creates a new schema column, it is recommended to name it clearly. For example: Client_Email. When adding a new column to a specific schema the following page opens:

A New Schema Column Page

The fields listed in this page define the new schema column name and default value – if one is assigned (optional). The toolbar options are described in the chapter: Introducing the Home Page.

 

To Create a New Schema Column:

  1. Select Interfaces> {Specific Interface}>Tasks > {Specific Task}>Schema.
  2. Click New.  The Schema Column page opens in a new window. 
  3. In the Name box, enter a relevant name for the new schema column. 
  4. In the Default Value box, enter default value for the new schema column.  The value will be entered into all the lines in this column.
  5. Select Data Type from the drop-down list.
  6. Click Save & Close to close the schema column and end the session, or click Save & New to save and close the current schema column begin a new session.

The new Schema column appears in the Navigation Pane and in the Schema Columns page.